package com.jzst.zzb;

import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;

import com.taihua.faxmail.gol.Database_mysql;

public class insertMysql {
	public String checkout(String s)
	{
		String flag="0";
		if(s.length()!=11)
		{
			flag="1";
		}
		 try{
			   int i=Integer.parseInt(s);   
			  }
			  catch(Exception e){
			  flag="1";
			  }
		return flag;
	}
	public static void main(String[] args) throws IOException {
		String filepath="d://";
		String file="text.sql";
		FileReader input = new FileReader(filepath+file);
		BufferedReader br = new BufferedReader(input);
		String s = br.readLine();
		String sql=null;
		Database_mysql db = new Database_mysql();

		
		while(s!=null){
			System.out.println(s);
			sql="insert into fee_bill_code (fee_username) values('"+s+"')";
			db.executeUpdate(sql);
			s = br.readLine();

		}
		br.close();
		input.close();
		

	}

}
